﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Runda.CMS.Bll;
using Runda.CMS.Common.Utility;
using Runda.CMS.Common.Entity;
using System.Data;

namespace Runda.CMS.Portal.Mobile
{
    public partial class DutyList : BasePage
    {
        private String @sql = "select top 10 * from  (select a.DutyID,a.Date,b.DuctyGroupName from Cms_Sys_Duty a join Cms_Sys_DutyGroup b on a.DutyGroupID = b.DutyGroupID) as ZZ where datediff(day,date,getdate()) <= 0 order by date asc";
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack) {
                BindList();
            }
        }

        private void BindList()
        {
            DataTable list = new CommonBll().getDataFromSQL(sql);

            myMaintainList.DataSource = list;
            myMaintainList.DataBind();
         
        }
    }
}
